SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529518 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529518 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111936,677873,471879,914916,643820,948791,394985,213078,549283,168523,838159,768046,540012,454666,1004166,576866,177831,1031943,217398,449680,965735,667541,743798,202392,982914,789801,168774,667450,50750,391487,995342,457798,321380,589303,261865,932194,614553,200427,706127,850694,609211,129495,161413,827040,593496,627464,1020031,737452,243437,997301,829421,76741,889558,618683,36475,545773,990694,49734,300654,192016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]