SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447580 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447580 [ RunTime:0.002794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34939,13269,398948,391027,911501,240758,825477,847453,814791,248496,513380,1038773,14541,527630,53689,367877,294508,246455,274279,881556,683081,26455,815186,605019,469545,803858,686812,492957,702875,27694,1017406,518510,264267,316995,664194,354877,999536,967275,256613,188865,469442,495814,1022980,520299,648308,84522,629970,865927,277887,948381,157452,313271,52951,1035647,865446,22836,623840,807505,747733,509893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]