SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002108 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002108 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115025,809017,367033,685878,499023,578691,55320,733749,712042,587977,195174,711663,930532,120330,203849,797061,643249,761875,299545,235952,395834,904900,794745,427140,721070,312439,84195,494968,13880,124132,145226,123154,903404,308676,657461,477161,710073,916356,317650,200071,774592,10909,1006739,551371,61502,989470,714333,271883,637388,1022768,999202,333604,434165,977161,822155,246089,478348,477676,768809,313028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]