SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001561s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 641843 LIMIT 1 [ RunTime:0.000596s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 641843 [ RunTime:0.003361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952798,320237,421391,9815,457735,584534,903863,260657,509263,711615,239367,601004,504269,158037,52865,894832,987047,834260,165445,829973,162081,201820,197261,781052,569269,480848,298779,382035,741556,385238,904754,844698,756484,906390,814857,7159,651265,711831,321037,912900,781828,1003364,590038,1014499,91192,398949,982203,787378,528264,682625,835281,442924,1029157,937741,447295,659755,661487,457693,923807,468188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 641843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 641843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001941s ]