SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480639 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480639 [ RunTime:0.001410s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350447,385204,583016,479234,174131,104905,591739,642298,143366,711957,220808,1045643,35636,74900,662728,1030556,620350,371442,999771,530992,484690,9281,352405,967748,36542,584877,154226,167685,476711,723545,548956,926915,884992,578984,232987,645832,357623,12883,158746,548058,139390,403484,296156,10868,285130,572684,455828,119406,273602,884428,101984,779797,53906,858216,219595,482018,483902,562715,918919,306957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]