SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012884 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012884 [ RunTime:0.004244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523778,454897,471877,606305,435510,353947,216582,794034,596760,346465,939136,690878,79124,535984,972526,878093,907470,589432,382413,1023966,76912,326039,774506,11985,408596,994917,882982,193436,747676,532941,701755,107860,189315,640318,511157,517957,87957,309495,321042,1993,42313,142079,675642,35110,533700,558318,594050,735929,245930,220449,111945,615299,36441,783397,791884,506609,1024746,210931,1018444,427041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]