SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514748 LIMIT 1 [ RunTime:0.001884s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514748 [ RunTime:0.004109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576932,812975,926663,545225,763255,155746,903498,425147,410773,270450,238012,122512,571798,303449,1013434,687356,825183,556838,796146,740389,620076,967705,702941,712402,541009,484928,711373,459733,553179,159115,734832,87917,755696,158,618847,746592,1229,192692,194318,867010,905361,219986,331164,275510,779130,1020298,948857,465036,490161,209891,250966,492803,329345,918767,379820,801390,647318,780057,216822,893340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001091s ]