SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261523 LIMIT 1 [ RunTime:0.003486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261523 [ RunTime:0.006700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555201,433772,897656,786735,359840,657059,343280,966514,993378,139580,375098,529381,854020,444770,582132,489196,150380,227675,395539,223935,976506,895709,473221,405488,274569,612387,260860,579039,8401,664909,253731,615556,8955,757907,180074,154352,367998,469421,315196,659608,237212,758437,309155,714543,188192,54787,186832,903454,749398,999139,489476,166358,543158,1040059,694142,407194,283112,97926,375062,242627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001041s ]