SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100170 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100170 [ RunTime:0.002464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848718,175713,210424,1020250,614408,545176,507330,90518,281894,271033,126727,944376,995058,148181,414874,94829,472115,514809,302367,676103,917728,209831,502711,969864,865196,459869,711601,7936,7282,982825,317774,661977,948207,680070,883329,109315,632901,482438,193234,707109,272657,1015611,441774,1032848,366666,844311,987989,286418,106736,772739,942756,201779,511737,213234,104139,692773,690083,130261,601101,445442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]