SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001697s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 251093 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 251093 [ RunTime:0.003164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897804,995679,139697,439577,288700,275015,739160,700556,462070,634444,249716,69507,636279,40607,380843,838906,986654,322645,564785,702496,60724,749751,440040,850956,55269,243794,497932,886606,913197,387136,340164,417733,636187,558722,212927,255939,641469,269868,548404,471847,13295,622256,379729,457700,34862,648316,249807,897925,222977,373869,152149,888865,198673,720247,698826,362626,189081,492209,469811,573245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 251093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 251093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003245s ]