SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042089 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042089 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017117,219307,911182,500729,244566,324321,2423,377910,1041959,388661,286607,669097,263028,809015,528765,103746,477680,886512,201602,795235,478121,611702,607450,432547,98981,233039,284914,475491,466791,247154,551843,503667,324236,562163,92368,859715,448169,73525,542222,809605,116550,108341,460208,20354,675192,743671,605177,691171,498675,1007449,812751,322566,72259,448739,623448,966804,236335,539708,31986,970586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]