SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29195 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29195 [ RunTime:0.002389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845958,544035,395498,1039457,154114,1030060,1032033,659511,1041999,572123,301777,262530,92817,545672,433426,706225,524096,905833,795101,20002,867885,1044213,393768,861720,830281,580898,335461,392193,334549,933067,181187,526065,644291,704004,547083,952085,1003958,22254,706009,902595,420569,626883,715877,342804,131099,1034512,139956,350755,38392,705576,961045,799076,122573,616549,966855,323425,372105,853347,432493,140792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29195 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29195 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]