SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543571 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543571 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201870,408679,138525,650074,120081,710150,402324,21884,197427,94161,922975,634074,1012528,32281,33577,328399,461822,277906,390010,15490,611216,84408,660207,1006423,670416,798538,117068,140851,277478,750570,922118,682069,808373,165673,220280,519327,1017490,43522,657292,161406,411243,442504,356194,375486,313254,616638,42828,1027976,20004,453530,280627,136850,807932,180361,438252,505759,489324,145623,973978,124544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]