SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012538 LIMIT 1 [ RunTime:0.002201s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012538 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876191,585318,152798,213723,59985,61181,642627,387319,427099,805572,239715,269880,986341,150090,795041,43470,721507,390955,1045615,686659,253241,1035485,676272,508220,340548,327026,506488,497946,186957,452791,341859,1038333,539052,750342,1013048,726466,191079,685480,284712,556706,904768,804301,364467,154757,599662,204874,566360,256136,881198,499492,737763,900557,291980,11986,597424,1040115,844661,867551,881373,990687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000377s ]