SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427680 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427680 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458169,712097,907103,199641,1048111,846269,931895,401230,712381,334256,227242,909644,353307,170618,267009,276753,811665,867830,824488,382978,1038432,596224,238709,54476,498392,629662,619370,159901,555389,749858,289825,213803,199754,207545,970544,485435,968426,217267,470285,393575,295123,299327,927835,690566,460865,824269,254080,449167,909785,394243,245075,983177,106800,184248,284588,769034,415342,224082,179604,491011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]