SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438130 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438130 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509208,557534,553283,945418,906888,386828,634090,1023666,433982,75889,285631,369150,1004290,349026,103113,41832,555290,283616,124785,76630,126312,10487,947622,919729,454339,40183,546556,363149,845930,58215,193962,347738,801317,309999,456660,625058,727186,571024,472009,749269,763990,774183,956525,116051,647129,194322,670124,375144,174053,1001732,2469,768979,249374,1027118,328598,260467,641669,382943,219708,745163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438130 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438130 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]