SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023136 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023136 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298810,907691,552123,498010,734219,182901,690345,499535,727875,102597,377528,557334,750790,275519,383539,705690,770137,1046649,594129,281782,599240,846447,559282,57718,483103,346734,897406,17248,895380,470156,164065,225187,435334,3067,866841,435759,167440,667859,644813,643595,975979,999058,689540,407807,393704,691468,83288,314721,382269,810838,710235,605773,284509,520837,452284,260931,198314,125464,641959,180070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]