SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142993 LIMIT 1 [ RunTime:0.004864s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142993 [ RunTime:0.006485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453696,907288,727047,610917,932758,217711,226704,711373,490510,638790,879259,309040,676441,962057,804499,196844,1024935,373539,271265,108107,284974,898000,507883,946295,134790,176173,78232,847967,536247,784166,385043,1010437,441209,28234,220328,572685,55410,893569,497820,934756,1015999,824121,174534,350640,702019,260846,995043,509095,539127,401882,48740,643200,71494,46899,515138,936155,1043415,790132,62763,907796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002180s ]