SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002908s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512781 LIMIT 1 [ RunTime:0.001520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512781 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146490,171498,184037,65821,1003311,418219,915657,175531,561500,994280,999616,391786,185642,878916,961531,350712,1014621,623309,351905,471323,462546,490110,1046123,962884,131431,359777,241148,546443,948087,910077,343003,216056,137889,250672,762117,613088,477719,444434,281527,399504,663604,717161,22470,897943,974024,117191,255007,665583,834862,667788,339779,239521,1030395,269921,400641,938740,531040,206489,329143,534187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]