SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29305 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29305 [ RunTime:0.002446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397001,221885,1017950,53577,469750,875369,390265,622554,586527,802493,947485,1030682,576384,297106,826501,571352,12511,881518,529122,1039012,339998,796975,614864,520018,798175,925474,88703,577088,284349,891384,669087,784888,948793,990096,173326,623436,609162,288056,465129,246963,43479,264079,766868,722819,946217,78099,414169,620850,304302,940355,109544,431161,948001,993540,364261,965016,292922,331945,2944,777841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001212s ]