SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984312 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984312 [ RunTime:0.002682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569025,788963,180352,1001693,17994,956439,911133,242404,933398,464467,911103,371782,988282,449584,115134,280838,649316,849007,593177,549343,204642,304728,195520,1029854,694269,951096,8361,841539,110218,527050,926820,843763,750763,657089,684769,846410,376890,997179,464303,360487,667671,452727,43504,800927,408876,653742,415139,480174,1010556,909800,749777,122299,803693,363311,331777,226233,512509,33751,195334,726867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]