SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001585s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199583 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199583 [ RunTime:0.010461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31550,281111,489845,684217,1044232,981038,84933,65702,160815,262033,176980,1012591,852817,679894,199522,724125,114424,568058,907624,330472,368979,570857,733282,662215,495867,340520,945188,643345,560155,527506,660421,176048,935751,529408,225223,587529,508782,714952,699062,721125,323856,355034,748139,653553,91596,1027901,987369,943968,703600,170006,178352,715757,685911,144460,1033900,426193,89529,443100,254950,83479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000975s ]