SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806555 LIMIT 1 [ RunTime:0.000941s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806555 [ RunTime:0.002231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952698,221118,204498,1015040,653624,501947,53388,518311,157938,405498,257198,784523,22617,1011626,877905,362361,684995,333453,505763,60909,180327,809158,639195,1008964,121797,812325,724013,717137,338990,461632,88498,408995,297163,1733,748727,1000032,65636,684509,975864,979542,618998,129732,32985,412594,739978,140116,643197,24794,642793,264148,71849,480487,275040,333291,391359,256687,422835,474743,306343,554308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806555 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806555 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]