SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456470 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456470 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920485,11747,408233,372186,679944,248463,627897,523163,465872,791342,160673,736016,260662,1023464,1047954,738294,195818,840875,506955,704256,417874,197448,792540,560433,124530,625919,273011,959813,881648,431312,71210,145780,870538,639120,67131,596924,1041552,389158,82561,938505,1032219,509896,917084,431076,228138,642465,842853,600708,460184,302317,207097,545344,463347,913322,582550,724843,824769,434951,279870,93073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001546s ]