SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109035 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109035 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761095,122806,518120,986282,114934,88588,584880,961198,622574,869974,50644,1015833,258501,384145,364828,673236,358781,171083,459565,205129,72173,186503,550309,901915,480591,563443,374338,955999,535391,717297,359294,885020,401770,684489,494336,497475,762305,754225,951433,432877,293560,178769,454082,432251,454845,909571,315480,13905,190345,373705,948098,388574,20630,57173,295945,90838,921121,461379,535421,126447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]