SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429113 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429113 [ RunTime:0.001334s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111365,321269,439328,460820,755597,1019341,217034,833294,942300,874691,329630,274461,288251,97316,1034704,44121,95918,306469,603053,147997,10953,344052,287299,788793,726734,115589,527421,365265,689513,283201,676844,612076,98606,425548,687763,1011486,905212,979639,725430,548858,62020,164243,570874,339678,366501,621298,66562,743619,115091,1048155,51288,249349,551580,520282,367077,736484,1038341,949637,137162,222349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]