SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205569 LIMIT 1 [ RunTime:0.000931s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205569 [ RunTime:0.003210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641067,291440,723696,635192,458562,750928,677622,223285,416308,869238,8508,426690,352280,291531,22080,98964,566182,970771,915107,705364,323739,154160,100666,502678,874838,379863,866687,819037,382879,697350,265733,353669,1012528,232343,167516,66583,817420,10632,710748,998412,908086,65392,622176,355443,803959,914474,943186,202317,940086,279933,387752,537366,330763,24731,351125,985361,981890,711445,8897,801604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001551s ]