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` = 148181 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148181 [ RunTime:0.005398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044834,712238,1036829,657183,444166,67938,237531,760923,267155,754735,335793,359704,51694,811004,175856,496171,1040147,589435,567244,361255,118454,79813,635966,924197,933612,880838,421532,439158,470937,276299,257076,312419,35250,553581,603764,666878,497325,810307,799873,496411,529858,740461,770407,133589,422539,106086,291153,679230,1010860,48537,203122,360486,800976,544752,734670,36794,860631,194198,177971,810934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]