SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524314 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524314 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759518,43905,538017,522951,1015462,982350,205406,148078,597323,202575,806132,484991,89113,756462,1001274,965871,117735,689351,423226,257534,182279,768115,742598,529900,161024,605747,883304,445666,751231,566336,610093,1041338,178461,852623,172996,267971,992888,223129,707514,958495,758456,346749,97312,212798,121865,49590,925587,686814,98472,716745,651886,109016,854441,583855,93888,3783,649333,216295,125221,523320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]