SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023589 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023589 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216636,410123,461756,317896,25457,695898,481846,774611,325424,961670,657860,67730,277121,840817,805406,330175,918781,774229,363139,262252,69990,160366,301525,350707,413658,824874,895752,336697,561330,280692,899310,415589,873835,970059,405465,856803,174496,334003,200746,146183,941167,232737,443192,546520,2810,245743,671649,507828,910304,745963,556643,1038668,189305,899848,228724,703278,962744,132454,899496,839672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]