SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305408 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305408 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208150,9515,432147,779821,1038554,1045698,58790,765707,302492,1012971,2830,326758,147303,428507,107617,543175,83069,1045726,164439,858572,518716,559983,717989,626869,392105,638406,572864,136357,989407,887143,248768,562366,1036638,628523,158544,281137,708641,970121,273817,1039148,1033961,199989,97555,231895,608912,10010,353029,346134,435542,456854,938680,775663,332308,89855,1045720,245832,421298,405444,606686,562015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]