SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018113 LIMIT 1 [ RunTime:0.001583s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018113 [ RunTime:0.004589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105896,36379,739390,131531,589306,988259,524039,134670,396215,131055,630017,744305,383580,480388,1003174,932241,323049,395255,283489,815491,857235,863610,622160,971586,658152,425811,891602,967058,690510,934445,772083,576991,433434,855036,639975,990850,578389,452046,182277,326152,97307,19774,689790,1004521,931343,695093,796761,951605,107597,220581,836332,301533,684694,835888,697186,870385,414837,1035291,702859,374707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]