SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001959s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46202 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46202 [ RunTime:0.003751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239228,95431,153996,982956,320543,210955,779488,321644,946122,697899,376760,604553,906967,908236,961611,885496,427233,892295,63664,922750,1043073,776665,532047,535794,386633,850977,157333,62050,1000873,961568,913296,898463,578681,271728,494534,1008158,464717,199146,875630,398913,635427,105981,854951,437596,788575,175032,131626,736002,1032519,831143,1027678,1036591,119577,17262,490873,183814,178019,983555,440246,576104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]