SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521053 LIMIT 1 [ RunTime:0.000554s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521053 [ RunTime:0.002504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993739,222670,211624,851599,164127,339452,864914,1031925,239721,571602,599279,44067,79264,833132,730786,546831,95534,714649,196022,690698,600252,152188,782253,135558,1038069,481757,742774,844759,535783,970296,31607,493346,563465,200348,730254,942177,242820,808043,93675,1021200,983850,688916,334198,123689,275105,242180,477344,220515,679622,425442,112495,694484,809069,731355,837042,892013,344644,303059,446312,945759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]