SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310061 LIMIT 1 [ RunTime:0.000565s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310061 [ RunTime:0.002600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322921,174984,308884,104588,261799,571231,183917,85600,674310,490535,42978,584602,413376,574423,178807,517896,910434,122599,313736,810894,885521,1044373,275351,552567,102968,691990,954298,961737,261879,258787,427112,438547,152848,596466,1010221,459444,282729,714056,976091,120240,698629,267166,902006,45050,64546,671385,178380,294203,732269,734699,554330,289304,257268,253267,948145,172524,790537,19873,642580,50468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]