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` = 318108 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318108 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178822,489382,850778,951129,419998,415592,188448,161030,803337,77185,373080,37482,563642,560950,325657,208802,36142,906175,406194,553318,1015866,852189,77580,33364,588175,341529,336659,864250,25694,843481,602137,532785,1032559,213980,1019580,746433,233492,392826,402133,107935,10354,280197,886309,208272,989476,712900,645783,560775,151057,240076,543712,982394,261330,158512,669340,302402,930495,968130,796600,870620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]