SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296710 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296710 [ RunTime:0.003369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254240,814038,23770,505957,512603,824750,34536,89801,477066,313469,101611,620278,107138,76686,1008380,569298,327345,396182,726899,928673,920066,203152,739401,994623,803978,676038,1027407,460081,933038,758369,613383,563785,200986,17995,557950,68766,54998,733505,515418,785642,1041735,625940,481205,751268,1036571,449537,1046607,150673,431514,107784,555707,997329,680442,240500,402344,72288,237592,359863,282113,510452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]