SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 772003 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 772003 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471328,621543,3837,1038224,344832,403777,596589,637033,672388,17461,539347,431146,361432,941349,399762,634560,762126,407601,24008,894292,982295,263619,708070,284455,28360,596104,273541,468140,112557,520417,909424,112382,668234,237155,822408,279394,808210,642456,1001156,812407,880880,878693,1040550,293098,1020303,258141,661744,833603,413839,260879,10906,105143,971333,500516,258319,203417,956519,602717,723951,428927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 772003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 772003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]