SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437249 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437249 [ RunTime:0.003046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975647,592282,550788,96900,991186,257403,827026,176208,691431,300741,732232,513502,418513,282460,425179,336521,350811,350692,822219,967979,1034000,166736,53227,733529,971741,127061,1015064,21547,388860,927889,736844,716923,26511,695499,1047710,687503,820874,1012434,143700,895899,330852,657626,209691,685594,32821,201809,994648,376022,384755,722748,535420,1048527,370815,456372,704605,252832,602948,940538,62368,608752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437249 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437249 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]