SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003799 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003799 [ RunTime:0.001507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273573,403301,120144,985200,602837,541592,648329,382063,172985,1027746,627670,819237,154436,601791,24735,138962,628282,225391,729800,317590,331470,81447,594449,110681,499589,806419,727140,292115,641908,205800,165202,281039,909949,402843,488327,71836,132222,355172,402019,286614,329437,181853,216250,966956,68864,648297,220192,845614,743771,853274,456129,188726,662281,1046651,153029,219322,883389,393631,447788,120674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003799 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003799 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]