SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469207 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469207 [ RunTime:0.003330s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435527,882694,980520,637220,45658,889621,126069,1009963,67618,742778,323440,63222,412201,472526,391657,375795,135958,13803,151430,82779,379508,753944,982734,15245,926443,589526,786998,218435,1041273,102620,562599,657489,90719,985189,179546,336314,137637,901820,34409,657095,411532,306625,396587,114020,496231,685309,35817,125354,286389,528750,231184,467809,161917,391590,908067,366076,803615,818625,338370,921357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000903s ]