SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201705 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201705 [ RunTime:0.005245s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845103,105061,36032,588497,188378,115449,488038,759100,307322,639743,459712,208480,509563,521083,998353,699831,306179,650002,813625,56900,210496,318014,496864,825500,315661,724415,490640,255734,966320,66497,6000,702099,737008,595464,577036,119245,546127,4956,319641,847038,723333,523741,422513,330059,556351,521530,312046,683575,767147,841765,747557,56006,677214,491899,515596,203215,644899,357176,361938,437753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000894s ]