SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393570 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393570 [ RunTime:0.001464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216302,95301,547800,70727,278133,48995,377264,781224,787269,1002881,855686,42664,197952,811468,72203,669661,157667,490073,537701,379401,618570,764796,275847,589631,714497,202538,24449,535254,1047019,735439,259789,966056,675741,5210,998163,831186,668257,941708,71431,738041,419978,83837,620051,854784,534337,513320,111474,873030,336091,102553,907108,552577,407271,121149,991505,121638,148590,431503,433985,780315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]