SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 646843 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 646843 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801518,147794,381491,126893,683787,391340,314760,649674,84778,201102,551131,398523,971637,350094,960257,376188,38008,519476,349891,939491,201283,351655,153035,559328,937664,334193,580293,995334,291828,822780,181033,458959,232113,171304,448752,469459,340384,522058,442081,290876,168219,1017843,1035561,248268,591865,634467,176231,469825,659898,902123,462860,714647,678003,212956,1023658,774134,831172,712003,873054,222762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 646843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 646843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]