SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316941 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316941 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768008,50389,762648,687311,77858,697765,750695,112228,724804,70751,608706,294675,511505,16780,826288,929682,646005,542190,23514,956212,213447,1019919,727218,229921,280232,255947,1014820,1030272,106139,86597,1035424,774460,108000,756237,328841,431366,628464,971964,548748,401392,389590,857538,659063,416953,36945,186508,1022724,189118,424214,734845,148664,824277,685735,171528,823579,406479,984323,35631,1935,498215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]