SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320615 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320615 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28366,39129,164438,181547,579767,274174,81613,212195,861121,795805,921144,820664,524074,561499,472268,659160,1023901,658112,1023472,354100,1045009,555079,931375,538998,761967,9970,233778,67642,198942,35473,569103,800904,380020,621048,274023,987757,435198,504236,285432,266263,378577,801308,464072,930955,340836,219554,979593,788356,618961,938265,530164,703464,124740,120335,596133,863910,137106,994788,649578,650135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000815s ]