SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281059 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281059 [ RunTime:0.002763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344239,578885,875061,1004240,623097,1000773,457888,507994,595812,103369,778083,210262,434525,300025,656587,166517,1000114,776612,100699,28357,631643,423130,841567,844983,360766,471841,294195,1006222,34977,375358,697411,734750,813053,172412,562665,457320,980794,480867,853618,880732,543207,272044,669927,973535,1002666,695625,380064,597568,90892,877994,855802,956829,523665,972234,204865,399078,542498,303162,69348,1020337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]