SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004631s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403555 LIMIT 1 [ RunTime:0.005108s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403555 [ RunTime:0.008379s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432721,877371,822855,158891,689106,968902,669443,727909,145651,797340,626218,1009501,202648,136159,852084,200192,478235,43514,478100,979134,52554,1040472,977566,517387,210111,681439,23598,816391,354503,797983,164727,585668,892333,333673,592053,599117,380071,543939,307486,196568,980958,312970,283288,879315,73190,595549,259010,207170,53680,445038,663308,465391,1013242,173797,40995,373550,645014,778056,753106,671301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403555 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403555 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005753s ]