SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549503 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549503 [ RunTime:0.001495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715521,834376,366036,750873,224149,936112,893331,10123,362319,814060,667356,587885,854618,499086,416823,528345,77178,645629,106513,523876,985034,198807,385058,132437,893829,426525,583310,1046090,382071,110956,749226,564895,353061,908130,153416,756351,173590,155180,371980,432862,754617,481752,351508,488977,908392,875725,131306,45600,62462,820247,693510,971950,682970,671610,55651,527327,76595,459302,1024963,793889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]