SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003710s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339683 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339683 [ RunTime:0.002346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037011,396938,512022,669877,627713,862328,441396,318402,482894,346133,694325,364486,646829,713874,629893,659423,962881,903237,320610,703026,1013483,975329,830888,1016162,426409,786465,872716,932593,585427,656328,575388,304384,700621,826368,797246,842759,960730,943061,960124,1265,1007545,952314,1021564,95777,567643,552830,925535,493556,774539,773956,127833,1040230,335322,420663,989546,592125,919380,860844,447594,346881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]