SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 916474 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 916474 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348898,72942,12498,501769,205900,155691,852167,60274,880089,633352,477811,888441,102882,708414,871036,567542,985783,252209,255391,625185,780246,100134,557709,236864,792095,202804,315670,19942,911077,758505,491352,96783,705298,563808,667403,581746,602892,23976,363238,217597,196008,999346,827815,305644,498461,678255,543322,775025,145014,735039,1035052,1000102,932753,447425,881504,844307,947554,612057,129244,763349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 916474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 916474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]