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` = 385093 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385093 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946771,159347,635607,197144,974639,6931,1047060,737712,267567,706319,535488,225794,66348,816621,179790,792501,312162,191494,901810,457086,208660,1042510,382114,388924,977611,54991,667099,577572,536381,772466,686636,439970,327838,814148,958676,64553,28014,378380,599848,913203,338676,390497,618880,940998,35200,452525,77505,976508,295733,1029936,467821,858820,491859,98974,480026,667269,270363,817081,557475,593813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]