SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001196 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001196 [ RunTime:0.002302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989006,1012371,783842,957910,794913,459734,951906,554556,57397,283960,578504,662400,389294,36375,235969,517868,526874,21149,174198,950158,333714,276222,760221,441522,886563,86026,770785,168921,64017,383480,722949,808831,329879,1010741,943136,128197,317658,888881,947583,699852,444049,676626,126058,91959,639739,877460,246918,524380,642809,842338,765194,535714,207669,52281,164936,222596,370638,522769,954034,160211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000802s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000968s ]