SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527651 LIMIT 1 [ RunTime:0.003654s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527651 [ RunTime:0.003983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715012,576705,588053,357874,548363,681542,661587,526693,728377,400646,354183,578607,608784,243236,802017,984933,346736,1043509,841674,280198,483855,418824,401312,609379,634417,1040025,310524,982204,105027,881406,97175,211018,311557,163786,288902,984700,822869,561944,770675,380537,339497,604663,491656,259537,793395,736279,542205,640751,417390,425133,904745,814263,646963,942654,766657,544380,67921,1028739,632090,27343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]