SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802011 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802011 [ RunTime:0.002820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (965671,549800,111563,336557,837925,601908,196861,931292,899592,201603,88326,347404,757933,832128,857884,572257,800291,718840,400141,919112,198209,392206,556963,171107,567213,282525,959721,22317,832595,716079,792019,42587,688606,336496,632357,748033,818292,179326,815923,961873,677205,435361,243850,208369,486059,10074,979617,595939,514548,865940,178603,557465,515870,836058,771292,33432,691202,920195,516577,727027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]