SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500552 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500552 [ RunTime:0.002023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783090,770210,116166,821183,21801,187332,268651,611747,296213,150959,621098,791934,1025672,490877,890130,172986,754765,261936,154352,407006,328331,892190,289045,907662,499658,581224,177489,748522,41917,48815,890994,785180,1020585,275650,150403,789975,364352,329738,877281,573321,768537,417283,108056,317752,777362,1021692,421054,443612,444867,797021,897301,506358,706686,987677,101344,318191,104026,338987,656581,300660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]