SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405129 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405129 [ RunTime:0.002009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525542,307140,647114,77277,718596,640110,448717,914557,252872,745198,1027358,231702,647860,876357,532151,11319,363540,540612,574421,455815,393218,170476,985617,278396,415543,1026930,77403,963897,351137,657448,593655,168535,433951,810379,934899,580774,995446,426397,68801,435194,170699,815004,532784,623861,238958,125950,738048,213202,796102,461179,228294,898622,644229,589334,153505,246588,992906,911350,182456,214439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405129 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405129 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]