SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328700 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328700 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475306,777587,70988,714353,277451,516737,1046080,363833,553793,448511,152442,104942,681158,956654,612875,607754,96299,58859,354417,579301,384684,576043,463216,57436,921621,314850,728200,483584,589098,837106,902778,207584,1025103,894167,388744,1022501,71347,371639,490429,288112,621068,522992,842849,634770,340464,876505,339545,623818,524420,884228,319788,304821,534891,495982,485055,409917,169942,143740,820842,415057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]