SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048042 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048042 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303729,963712,783288,26129,465664,804803,440408,932256,279903,579366,314193,123373,131879,992938,294113,386105,607780,748069,899436,817989,532457,607323,684768,949881,864193,879347,435083,80087,502246,815639,1036610,30299,614612,238721,181112,989427,104106,490441,341587,729886,678280,194807,229057,205044,570135,348716,1006954,973313,491607,1027398,735950,1021557,1038638,825545,33024,340905,186712,450611,930720,701618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]