SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003191 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003191 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792635,383314,579478,585719,676404,22639,707448,235549,600377,898342,453905,142945,882044,446986,736498,212522,40570,798988,121533,825339,966599,908552,272664,418981,933436,599032,454658,455162,680218,702740,820087,202672,287026,397005,303056,775041,238223,1030872,883555,63975,123789,726842,478519,353235,370476,1035880,639884,423957,594407,756801,252968,327160,348328,115617,263499,856952,403065,223765,149081,448538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]