SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453914 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453914 [ RunTime:0.003314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60358,298846,496213,473400,554147,441315,653825,488416,781961,373896,65933,160534,511070,453991,942329,1045516,357064,608949,901045,309662,1039457,1036128,144284,609636,182356,648499,612313,840104,138696,50011,511782,297849,711066,877523,616242,790054,613175,902975,378580,358680,299691,431483,78554,547862,1027175,703476,512330,721908,56484,615243,884296,355354,400713,198541,1033579,443406,498539,733496,170900,47934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]