SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 900621 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 900621 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625178,278614,275540,318831,496358,497494,165470,82561,433730,67376,268252,890070,65255,436440,47805,225500,759182,911437,334950,75127,217654,193134,517908,511229,320277,169353,321099,696829,222930,890219,172318,939432,835891,420851,1042942,582403,4058,616003,85070,149573,854288,1036527,326241,82247,532712,926638,138556,223559,144753,773742,86496,904925,1047324,60289,322399,361071,379324,410317,836000,883814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 900621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 900621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]