SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291413 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291413 [ RunTime:0.002545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645563,28290,498964,295734,352018,1031286,642639,426976,864817,687091,519162,32532,532148,686524,308562,566530,596424,859912,14628,461807,888145,622775,931134,400838,990610,91495,978843,385368,314956,479647,722592,598939,765404,32323,755665,504526,288478,895755,997638,674460,742669,926686,603443,730583,220171,634416,923247,251720,584658,147677,726168,223358,75852,732728,464952,829056,582887,792615,813205,882541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]