SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555601 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555601 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234769,933169,127055,183046,95840,412048,283241,904573,307310,69151,966178,723403,106253,54981,357559,292403,841603,636241,841193,810017,843032,858249,1023173,1009357,622697,135207,286076,80125,473708,183811,640170,300987,976802,839490,768733,1015228,462001,540241,881964,21882,980940,866233,874735,968244,63184,564074,327136,775256,859774,314940,758929,254243,14631,97618,904885,232903,893692,437900,19651,640845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]