SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4161 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4161 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558296,62355,184795,135892,707861,539234,135590,528673,632136,450579,1040053,632014,139711,530995,917616,939866,2420,41202,28663,1023072,520363,460494,560271,75757,709710,90597,822578,790814,907842,497974,186704,431006,154406,127633,271998,772970,488849,474927,967462,206105,607449,609515,582577,1008755,413129,688910,969902,1044761,234735,581044,984256,613250,643292,1023951,595795,177839,416586,557531,655476,309658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]