SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037090 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037090 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440032,970128,622586,933461,206699,829711,930187,655814,826307,999019,228063,792662,538167,399970,1003401,170106,998420,135534,472505,599397,112492,480349,452164,861171,997115,887463,130384,39540,164322,295535,310212,914792,207031,785804,418121,198493,557451,462788,813444,254519,293841,432829,777422,103815,453640,66866,713962,1009945,919387,679810,699064,233303,771332,262377,992112,877108,570418,457848,371360,934270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]