SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394051 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394051 [ RunTime:0.002240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871570,714817,703233,133748,659450,345074,596900,131037,378234,888321,487475,119079,297806,657803,665165,414622,252060,660991,620556,44523,612524,664116,957073,9579,639748,878800,13854,186051,1048115,271575,670905,182367,1016588,419355,1048633,867189,215956,1033336,1025379,832607,587106,888711,915676,844541,851702,844163,690716,497570,529901,26039,751125,71584,874556,914881,979804,368806,581886,181507,264320,277748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]