SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 247243 LIMIT 1 [ RunTime:0.000849s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 247243 [ RunTime:0.002648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40220,454742,833760,482626,483546,333453,765719,693651,859928,445226,546094,124421,737967,990494,647239,915650,329776,543546,8818,432738,749314,562881,533064,1040740,401085,594977,452626,740269,1002658,919143,985967,1036209,516469,870765,48023,481197,372279,397599,499120,681470,903894,259426,205277,869613,365139,175850,135698,824014,393997,50042,853018,880531,349892,854453,544162,520485,807750,496797,683083,821876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 247243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 247243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003892s ]