SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 995418 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 995418 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294567,708054,773242,128471,64742,36085,210999,568319,829803,382546,240761,1037702,855563,182403,776301,800216,603611,1030312,714968,904195,971929,81429,178854,228628,125135,410030,208226,494524,560684,726667,320074,134150,493632,199047,579246,660495,441835,563357,242025,644749,758754,311200,930147,11314,403665,968661,657405,568403,279807,576576,416453,123658,857387,27800,98744,630656,123108,451493,125805,473468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 995418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 995418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]